Skip to main content
Download what the grid shows, the rows you ticked, or whole tables from the Tables list. Each comes as a CSV or an Excel workbook.
The menu under a table's name listing Table settings, Export to file, a greyed-out Run failed rows and Credit usage, with a submenu beside it offering Export to CSV (.csv) and Export to Microsoft Excel (.xlsx), over the table's rows.

The table's own menu, open on the export formats.

​
Download a table

1

Open the export menu

On your table, click its name at the top of the page, then Export to file. The Tools panel offers the same row under Import & export.
2

Pick the file

Choose Export to CSV (.csv) or Export to Microsoft Excel (.xlsx). The file downloads straight away.
The file matches the grid. Your current filter, sort and column order all carry across, and hidden columns stay out. To export a selection instead, tick some rows and click Export in the bar that appears. It offers the same two files.

​
Export from the Tables list

Export whole tables without opening them. On Tables, tick the tables and click Export. For one table, you can also open the table’s row menu and choose Export to file. A table exported from the list holds every column and every row, up to the same ceiling as any export. Several tables download as one zip file, with a file for each table.

​
Choose a format

Both files hold the same rows. They differ in what survives the trip.
  • CSV writes everything as text. Dates come out in ISO 8601 and lists and objects as JSON, so the file imports back cleanly.
  • Excel keeps types. Numbers stay summable, dates sort as dates, and checkboxes stay true or false.
Pick Excel to work in a spreadsheet, and CSV to feed another system.

​
Good to know

The table’s name, what you exported, and the moment you did it. What you exported reads view for the grid, selection for ticked rows, or table for a whole table from the Tables list.A file found weeks later traces back to what produced it. The table’s activity history records the same name. A zip from the Tables list is named for the moment you exported it.
Oneprofile could not export it. The download still holds every other table, and a message says how many were left out and why. When only one table is left, it arrives as its own file rather than a zip.
A spreadsheet reads a leading = as a formula, so a CSV protects you by writing a quote in front of that cell.An Excel export needs no quote, because Oneprofile writes those cells as text that Excel never evaluates. The text you see is exactly what was in the table.
Oneprofile exports up to a ceiling and adds a final row saying it stopped. Narrow the view with a filter and export again. From the Tables list, open the table first, filter it, and export from there.A CSV starts downloading immediately. An Excel workbook is built in full first, so a big one takes a moment before the download begins.

​
Next steps

Import a file

Bring a CSV or Excel file in as a new table.

Export to a tool

Push rows to a connected system instead of a file.

Filter, sort and search

Narrow the grid before you export it.