Skip to content
English
More support
Contact us
  • There are no suggestions because the search field is empty.

Exporting from and Importing into the AIM table

This article guides you step by step through both importing and exporting: how to export an AIM table to CSV and how to import data into an AIM table.


Exporting the AIM table to .csv

  1. Open any AIM table.
  2. Click the three dots on the top right, then Export to .csv.
  3. Choose the delimiter you want to use. 
  4. Choose columns to include (by default it selects all visible columns + highlight information)
  5. Download starts
  6. CSV export flattens every property - boolean, tag, and user fields - into a plain-text column.


How to import CSV into an Existing Table

  1. In the target table, click the three dots on the top right then Import data.
  2. Upload a CSV (often the same file previously exported & enriched).
  3. Choose the delimiter you want to use. Be aware that Numbers (Mac) will always change the delimiter to semicolon once you export the file. 
  4. After uploading the CSV, choose the matching AIM column for each CSV header (no auto-suggestions are provided)
  5. Only text‑type columns are eligible → unmatched/unsupported columns ignored.
  6. New rows are appended; existing rows remain unchanged (no merge/overwrite).

When working with CSV files, the delimiter determines how columns are separated in the file. The most common delimiter is a comma (,), but not all tools or regions use the same standard. For example, some European versions of Excel—especially those using a comma as the decimal separator—default to using a semicolon (;) as the delimiter.

To ensure that AIM data is displayed and interpreted correctly when opened in tools like Excel or re-imported into AIM, we give users the option to explicitly choose the delimiter. This prevents formatting issues, like data ending up in a single column or breaking the structure of the table.

How to work with .csv?

When you open a CSV file and all the data appears in a single column, this is usually due to a delimiter mismatch. Here’s how to fix it:

Open a CSV and split the content into separate columns in Excel:
  1. Open Excel and go to the “Data” tab.
  2. Click “From Text/CSV” and select your CSV file.
  3. Excel will show a preview. Choose the correct delimiter (comma or semicolon, depending on your region/tool).
  4. Click “Load” to import the data into separate columns.

If you’ve already opened the file and see everything in one column:

  1. Select the column.
  2. Go to “Data” > “Text to Columns”.
  3. Choose “Delimited”, click Next.
  4. Select the correct delimiter (comma or semicolon), click Finish.

Not sure which delimiter to use? Try opening the file in a text editor first (like Notepad or VS Code) to check what separates the columns