Pivot Table Import/Export

Importing Files with Pivot Tables

Importing XSLX

1. Save the file from your preferred program
2. Open Confluence
3. Insert a new Excellentable into your desired Space or open a previously created one in your desired Space
4. Select File > Import > Select XLSX file with Pivot Table in it

Importing CSV

1. Save the file from your preferred program
2. Open Confluence
3. Insert a new Excellentable into your desired Space or open a previously created one in your desired Space
4. Select File > Import > Select CSV file with Pivot Table in it

Exporting Files with Pivot Tables

Exporting XSLX

1. Open Confluence
2. Create a new Excellentable in your desired Space or open a previously created one in your desired Space
3. Select File > Export > XSLX
4. Save file to your desired location

Exporting CSV

1. Open Confluence
2. Create a new Excellentable in your desired Space or open a previously created one in your desired Space
3. Select File > Export > CSV
4. Save file to your desired location

Exporting PDF

1. Open Confluence
2. Create a new Excellentable in your desired Space or open a previously created one in your desired Space
3. Select File > Export > PDF
4. Save file to your desired location

Exporting HTML

1. Open Confluence
2. Create a new Excellentable in your desired Space or open a previously created one in your desired Space
3. Select File > Export > HTML
4. Save file to your desired location

Known Issues

Importing Files with a Pivot Table from Google Sheets

• There is an issue with Importing XLSX files that were Exported from Google Sheets. This is a known error and we are working to fixing the issue.
  
  • Two ways to get around the issue.
    1. You must open the file in a separate Table Program (Excel, Numbers, etc.) and save it again as an XLSX.
    2. Export the file from Google Sheets as a file type different than XLSX and Import that file.