...
Some preparation of the spreadsheet maybe required in order to import the data such as ensuring the formatting of the cells is consistent and that column names only contain characters deemed valid for column names in PostgreSQL. In practice this usually means removing punctuation and non alphanumeric characters including spaces from column headings. It may also be necessary to delete empty rows/columns if selecting all data within a Worksheet to avoid blank columns and rows being imported.
| Tip |
|---|
If you wish to import an XLSX file into Data Share the easiest way to do this is to either export to the old XLS format and follow the steps below or to CSV file and follow the steps on importing CSV Files. |
Working with the Datasource in Data Share
...